Production Database Systems: Making Them Easy is Hard Work
نویسنده
چکیده
Enterprise capable database products have evolved into incredibly complex systems, some of which present hundreds of configuration parameters to the system administrator. So, while the processing and storage costs for maintaining large volumes of data have plummeted, the human costs associated with maintaining the data have continued to rise. In this presentation, we discuss the framework and approach used by the team who took Microsoft SQL Server from a state where it had several hundred configuration parameters to a system that can configure itself and respond to changes in workload and environment with little human intervention.
منابع مشابه
Simultaneous production planning and scheduling in a hybrid flow shop with time periods and work shifts
Simultaneous production planning and scheduling has been identified as one of the most important factors that affect the efficient implementation of planning and scheduling operations for the production systems. In this paper, simultaneous production planning and scheduling is applied in a hybrid flow shop environment, which has numerous applications in real industrial settings. In this problem...
متن کاملCSUG/SPE 149485 SeTES: A Self-Teaching Expert System for the Analysis, Design, and Prediction of Gas Production From Unconventional Gas Resources
SeTES is a self-teaching expert system that (a) can incorporate evolving databases involving any type and amount of relevant data (geological, geophysical, geomechanical, stimulation, petrophysical, reservoir, production, etc.) originating from unconventional gas reservoirs, i.e., tight sands, shale or coalbeds, (b) can continuously update its built-in 'public' database and refine the its under...
متن کاملImplementing File Systems by XML-aware Databases
We will—once again—arise the old question what systems are best suited for management of data. Today, persistent data is stored in file systems and databases. While the first provide an easy and wellunderstood interface to the data, they lack important features of the second, like, for example, the ability to query the data. Nowadays hard disks are increasingly used to store personal informatio...
متن کاملStudy on implementation of one-piece lean line design using simulation techniques: A practical approach
This paper discusses the simulation study carried out for proposing one-piece lean line layout with features of Lean Manufacturing. The lean initiatives that can be addressed are, introducing Kanban replenishment sys-tem, better work-in-process, changing the layout, visual management techniques, standardized work for the re-duction of cycle time, number of workers, number of setups. To improve ...
متن کاملScalable Public Transportation Queries on the Database
Recent scientific literature focuses on answering Earliest Arrival (EA), Latest Departure (LD) and Shortest Duration (SD) queries in (schedule-based) public transportation networks. Unfortunately, most of the existing solutions operate in main memory, making the proposed methods hard to scale for larger instances and difficult to integrate in a multi-user environment. This work proposes PTLDB (...
متن کامل